ALTER TABLE [dbo].[fun_funcionario]
ADD [car_cargo_car_id] [INT] NOT NULL
GO

ALTER TABLE [dbo].[fun_funcionario]
ADD [UserId] [uniqueidentifier] NOT NULL
GO

ALTER TABLE [dbo].[fun_funcionario] 
DROP COLUMN fun_cargo;
GO

ALTER TABLE [dbo].[fun_funcionario] 
DROP COLUMN fun_cargaHoraria;
GO

ALTER TABLE [dbo].[fun_funcionario] 
DROP COLUMN fun_salarioBase;
GO

ALTER TABLE [dbo].[fun_funcionario]  WITH CHECK ADD FOREIGN KEY([car_cargo_car_id])
REFERENCES [dbo].[car_cargo] ([car_id])
GO

ALTER TABLE [dbo].[fun_funcionario]  WITH CHECK ADD FOREIGN KEY([UserId])
REFERENCES [dbo].[apsnet_Users] ([UserId])
GO

